
insert into brperp_elcon_sw_v12_db_test.tbl_common_category_mst  select * from bigdatas_umaboy_erp.tbl_common_category_mst;
insert into brperp_elcon_sw_v12_db_test.tbl_common_mst  select * from bigdatas_umaboy_erp.tbl_common_mst;
insert into brperp_elcon_sw_v12_db_test.tbl_financial_year  select * from bigdatas_umaboy_erp.tbl_financial_year;
insert into brperp_elcon_sw_v12_db_test.tbl_tax_category  select * from bigdatas_umaboy_erp.tbl_tax_category;
insert into brperp_elcon_sw_v12_db_test.tbl_tax_category_details  select * from bigdatas_umaboy_erp.tbl_tax_category_details;
insert into brperp_elcon_sw_v12_db_test.tbl_tds_tax_category  select * from bigdatas_umaboy_erp.tbl_tds_tax_category;
insert into brperp_elcon_sw_v12_db_test.tbl_tds_tax_category_detail  select * from bigdatas_umaboy_erp.tbl_tds_tax_category_detail;

update `tbl_ledger` set l_status='1',l_name='cgst1'  WHERE `l_name` LIKE 'cgst';

INSERT INTO `tbl_ledger` (`l_id`, `l_name`, `ledger_code`, `emp_profile_img`, `l_group`, `l_form`, `countryid`, `stateid`, `cityid`, `cust_pincode`, `m_name`, `m_address`, `m_pan`, `company_name`, `cust_cont_name`, `cust_mobile`, `cust_email`, `cust_website`, `zone_id`, `cust_assign_user`, `branch_id_customer`, `party_sez`, `branch_id_employee`, `cust_remark`, `gst_no`, `party_type`, `cust_gst_reg`, `pay_terms`, `pay_method`, `bill_type`, `balance_typeid`, `acc_type`, `bankid`, `branch_name`, `acc_name`, `acc_number`, `acc_chequeno`, `acc_chequeleft`, `emp_mobile`, `emp_email`, `emp_password`, `emp_zone_id`, `emp_user_type`, `tax_value`, `opn_balance`, `usertype_terr`, `alloc_stateid`, `alloc_cityid`, `report_to_user_type`, `report_to_user_id`, `cdate`, `user_id`, `company_id`, `l_status`, `print_priority`, `cust_id`, `employee_id`, `branch_id`, `credit_limit`, `credit_days`, `is_deletable`, `ledger_alias`, `enable_multi_currency_opening`, `enable_branch_opening`, `ledger_opening_balance_type`, `enable_cost_center`, `enable_tds`, `party_pay_cat`, `enable_tcs`, `enable_depreciation`, `enable_monthly_budget`, `ledger_Tax_type`, `ledger_gst_applicable`, `ledger_tax_category`, `ledger_hsn`, `ledger_itc`, `ledger_rcm`, `enable_bill_sunfry`, `enable_sez`, `enable_cheque_deposit`, `enable_billbybill_opening`, `default_sundry`, `enable_salesman`,`default_ledger`) VALUES ('9870', 'CGST', '', '', '31', 'tax_form', '101', '1', '1', '380015', '0', '0', 'CXNSHSSD', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0.00', '0', '0', '0', '0', '0', '0', '9', '0.00', '0', '0', '0', '0', '0', '2021-01-26 14:35:03', '1', '1', '0', '2', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '0', '1', '0', '0', '0', '1', '0','1');



update `tbl_ledger` set l_status='1',l_name='sgst1'  WHERE `l_name` LIKE 'sgst';

INSERT INTO `tbl_ledger` (`l_id`, `l_name`, `ledger_code`, `emp_profile_img`, `l_group`, `l_form`, `countryid`, `stateid`, `cityid`, `cust_pincode`, `m_name`, `m_address`, `m_pan`, `company_name`, `cust_cont_name`, `cust_mobile`, `cust_email`, `cust_website`, `zone_id`, `cust_assign_user`, `branch_id_customer`, `party_sez`, `branch_id_employee`, `cust_remark`, `gst_no`, `party_type`, `cust_gst_reg`, `pay_terms`, `pay_method`, `bill_type`, `balance_typeid`, `acc_type`, `bankid`, `branch_name`, `acc_name`, `acc_number`, `acc_chequeno`, `acc_chequeleft`, `emp_mobile`, `emp_email`, `emp_password`, `emp_zone_id`, `emp_user_type`, `tax_value`, `opn_balance`, `usertype_terr`, `alloc_stateid`, `alloc_cityid`, `report_to_user_type`, `report_to_user_id`, `cdate`, `user_id`, `company_id`, `l_status`, `print_priority`, `cust_id`, `employee_id`, `branch_id`, `credit_limit`, `credit_days`, `is_deletable`, `ledger_alias`, `enable_multi_currency_opening`, `enable_branch_opening`, `ledger_opening_balance_type`, `enable_cost_center`, `enable_tds`, `party_pay_cat`, `enable_tcs`, `enable_depreciation`, `enable_monthly_budget`, `ledger_Tax_type`, `ledger_gst_applicable`, `ledger_tax_category`, `ledger_hsn`, `ledger_itc`, `ledger_rcm`, `enable_bill_sunfry`, `enable_sez`, `enable_cheque_deposit`, `enable_billbybill_opening`, `default_sundry`, `enable_salesman`,`default_ledger`) VALUES ('9880', 'SGST', '', '', '31', 'tax_form', '101', '1', '1', '380015', '0', '0', 'CXNSHSSD', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0.00', '0', '0', '0', '0', '0', '0', '9', '0.00', '0', '0', '0', '0', '0', '2021-01-26 14:35:03', '1', '1', '0', '2', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '0', '1', '0', '0', '0', '1', '0','1');


update `tbl_ledger` set l_status='1',l_name='igst1'  WHERE `l_name` LIKE 'igst';

INSERT INTO `tbl_ledger` (`l_id`, `l_name`, `ledger_code`, `emp_profile_img`, `l_group`, `l_form`, `countryid`, `stateid`, `cityid`, `cust_pincode`, `m_name`, `m_address`, `m_pan`, `company_name`, `cust_cont_name`, `cust_mobile`, `cust_email`, `cust_website`, `zone_id`, `cust_assign_user`, `branch_id_customer`, `party_sez`, `branch_id_employee`, `cust_remark`, `gst_no`, `party_type`, `cust_gst_reg`, `pay_terms`, `pay_method`, `bill_type`, `balance_typeid`, `acc_type`, `bankid`, `branch_name`, `acc_name`, `acc_number`, `acc_chequeno`, `acc_chequeleft`, `emp_mobile`, `emp_email`, `emp_password`, `emp_zone_id`, `emp_user_type`, `tax_value`, `opn_balance`, `usertype_terr`, `alloc_stateid`, `alloc_cityid`, `report_to_user_type`, `report_to_user_id`, `cdate`, `user_id`, `company_id`, `l_status`, `print_priority`, `cust_id`, `employee_id`, `branch_id`, `credit_limit`, `credit_days`, `is_deletable`, `ledger_alias`, `enable_multi_currency_opening`, `enable_branch_opening`, `ledger_opening_balance_type`, `enable_cost_center`, `enable_tds`, `party_pay_cat`, `enable_tcs`, `enable_depreciation`, `enable_monthly_budget`, `ledger_Tax_type`, `ledger_gst_applicable`, `ledger_tax_category`, `ledger_hsn`, `ledger_itc`, `ledger_rcm`, `enable_bill_sunfry`, `enable_sez`, `enable_cheque_deposit`, `enable_billbybill_opening`, `default_sundry`, `enable_salesman`,`default_ledger`) VALUES ('9890', 'IGST', '', '', '31', 'tax_form', '101', '1', '1', '380015', '0', '0', 'CXNSHSSD', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0.00', '0', '0', '0', '0', '0', '0', '9', '0.00', '0', '0', '0', '0', '0', '2021-01-26 14:35:03', '1', '1', '0', '2', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '0', '1', '0', '0', '0', '1', '0','1');



SELECT * FROM `tbl_ledger` WHERE `l_name` LIKE 'tds';


INSERT INTO `tbl_ledger` (`l_id`, `l_name`, `ledger_code`, `emp_profile_img`, `l_group`, `l_form`, `countryid`, `stateid`, `cityid`, `cust_pincode`, `m_name`, `m_address`, `m_pan`, `company_name`, `cust_cont_name`, `cust_mobile`, `cust_email`, `cust_website`, `zone_id`, `cust_assign_user`, `branch_id_customer`, `party_sez`, `branch_id_employee`, `cust_remark`, `gst_no`, `party_type`, `cust_gst_reg`, `pay_terms`, `pay_method`, `bill_type`, `balance_typeid`, `acc_type`, `bankid`, `branch_name`, `acc_name`, `acc_number`, `acc_chequeno`, `acc_chequeleft`, `emp_mobile`, `emp_email`, `emp_password`, `emp_zone_id`, `emp_user_type`, `tax_value`, `opn_balance`, `usertype_terr`, `alloc_stateid`, `alloc_cityid`, `report_to_user_type`, `report_to_user_id`, `cdate`, `user_id`, `company_id`, `l_status`, `print_priority`, `cust_id`, `employee_id`, `branch_id`, `credit_limit`, `credit_days`, `is_deletable`, `ledger_alias`, `enable_multi_currency_opening`, `enable_branch_opening`, `ledger_opening_balance_type`, `enable_cost_center`, `enable_tds`, `party_pay_cat`, `enable_tcs`, `enable_depreciation`, `enable_monthly_budget`, `ledger_Tax_type`, `ledger_gst_applicable`, `ledger_tax_category`, `ledger_hsn`, `ledger_itc`, `ledger_rcm`, `enable_bill_sunfry`, `enable_sez`, `enable_cheque_deposit`, `enable_billbybill_opening`, `default_sundry`, `enable_salesman`,`default_ledger`) VALUES ('9891', 'TDS', '', '', '31', 'tax_form', '101', '1', '1', '380015', '0', '0', 'CXNSHSSD', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0.00', '0', '0', '0', '0', '0', '0', '9', '0.00', '0', '0', '0', '0', '0', '2021-01-26 14:35:03', '1', '1', '0', '2', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '0', '1', '0', '0', '0', '1', '0','1');



INSERT INTO `tbl_ledger` (`l_id`, `l_name`, `ledger_code`, `emp_profile_img`, `l_group`, `l_form`, `countryid`, `stateid`, `cityid`, `cust_pincode`, `m_name`, `m_address`, `m_pan`, `company_name`, `cust_cont_name`, `cust_mobile`, `cust_email`, `cust_website`, `zone_id`, `cust_assign_user`, `branch_id_customer`, `party_sez`, `branch_id_employee`, `cust_remark`, `gst_no`, `party_type`, `cust_gst_reg`, `pay_terms`, `pay_method`, `bill_type`, `balance_typeid`, `acc_type`, `bankid`, `branch_name`, `acc_name`, `acc_number`, `acc_chequeno`, `acc_chequeleft`, `emp_mobile`, `emp_email`, `emp_password`, `emp_zone_id`, `emp_user_type`, `tax_value`, `opn_balance`, `usertype_terr`, `alloc_stateid`, `alloc_cityid`, `report_to_user_type`, `report_to_user_id`, `cdate`, `user_id`, `company_id`, `l_status`, `print_priority`, `cust_id`, `employee_id`, `branch_id`, `credit_limit`, `credit_days`, `is_deletable`, `ledger_alias`, `enable_multi_currency_opening`, `enable_branch_opening`, `ledger_opening_balance_type`, `enable_cost_center`, `enable_tds`, `party_pay_cat`, `enable_tcs`, `enable_depreciation`, `enable_monthly_budget`, `ledger_Tax_type`, `ledger_gst_applicable`, `ledger_tax_category`, `ledger_hsn`, `ledger_itc`, `ledger_rcm`, `enable_bill_sunfry`, `enable_sez`, `enable_cheque_deposit`, `enable_billbybill_opening`, `default_sundry`, `enable_salesman`,`default_ledger`) VALUES ('9893', 'CESS', '', '', '31', 'tax_form', '101', '1', '1', '380015', '0', '0', 'CXNSHSSD', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0.00', '0', '0', '0', '0', '0', '0', '9', '0.00', '0', '0', '0', '0', '0', '2021-01-26 14:35:03', '1', '1', '0', '2', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '0', '1', '0', '0', '0', '1', '0','1');


INSERT INTO `tbl_ledger` (`l_id`, `l_name`, `ledger_code`, `emp_profile_img`, `l_group`, `l_form`, `countryid`, `stateid`, `cityid`, `cust_pincode`, `m_name`, `m_address`, `m_pan`, `company_name`, `cust_cont_name`, `cust_mobile`, `cust_email`, `cust_website`, `zone_id`, `cust_assign_user`, `branch_id_customer`, `party_sez`, `branch_id_employee`, `cust_remark`, `gst_no`, `party_type`, `cust_gst_reg`, `pay_terms`, `pay_method`, `bill_type`, `balance_typeid`, `acc_type`, `bankid`, `branch_name`, `acc_name`, `acc_number`, `acc_chequeno`, `acc_chequeleft`, `emp_mobile`, `emp_email`, `emp_password`, `emp_zone_id`, `emp_user_type`, `tax_value`, `opn_balance`, `usertype_terr`, `alloc_stateid`, `alloc_cityid`, `report_to_user_type`, `report_to_user_id`, `cdate`, `user_id`, `company_id`, `l_status`, `print_priority`, `cust_id`, `employee_id`, `branch_id`, `credit_limit`, `credit_days`, `is_deletable`, `ledger_alias`, `enable_multi_currency_opening`, `enable_branch_opening`, `ledger_opening_balance_type`, `enable_cost_center`, `enable_tds`, `party_pay_cat`, `enable_tcs`, `enable_depreciation`, `enable_monthly_budget`, `ledger_Tax_type`, `ledger_gst_applicable`, `ledger_tax_category`, `ledger_hsn`, `ledger_itc`, `ledger_rcm`, `enable_bill_sunfry`, `enable_sez`, `enable_cheque_deposit`, `enable_billbybill_opening`, `default_sundry`, `enable_salesman`,`default_ledger`) VALUES ('9894', 'ADD.CESS', '', '', '31', 'tax_form', '101', '1', '1', '380015', '0', '0', 'CXNSHSSD', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0.00', '0', '0', '0', '0', '0', '0', '9', '0.00', '0', '0', '0', '0', '0', '2021-01-26 14:35:03', '1', '1', '0', '2', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '0', '1', '0', '0', '0', '1', '0','1');




INSERT INTO `tbl_ledger` (`l_id`, `l_name`, `ledger_code`, `emp_profile_img`, `l_group`, `l_form`, `countryid`, `stateid`, `cityid`, `cust_pincode`, `m_name`, `m_address`, `m_pan`, `company_name`, `cust_cont_name`, `cust_mobile`, `cust_email`, `cust_website`, `zone_id`, `cust_assign_user`, `branch_id_customer`, `party_sez`, `branch_id_employee`, `cust_remark`, `gst_no`, `party_type`, `cust_gst_reg`, `pay_terms`, `pay_method`, `bill_type`, `balance_typeid`, `acc_type`, `bankid`, `branch_name`, `acc_name`, `acc_number`, `acc_chequeno`, `acc_chequeleft`, `emp_mobile`, `emp_email`, `emp_password`, `emp_zone_id`, `emp_user_type`, `tax_value`, `opn_balance`, `usertype_terr`, `alloc_stateid`, `alloc_cityid`, `report_to_user_type`, `report_to_user_id`, `cdate`, `user_id`, `company_id`, `l_status`, `print_priority`, `cust_id`, `employee_id`, `branch_id`, `credit_limit`, `credit_days`, `is_deletable`, `ledger_alias`, `enable_multi_currency_opening`, `enable_branch_opening`, `ledger_opening_balance_type`, `enable_cost_center`, `enable_tds`, `party_pay_cat`, `enable_tcs`, `enable_depreciation`, `enable_monthly_budget`, `ledger_Tax_type`, `ledger_gst_applicable`, `ledger_tax_category`, `ledger_hsn`, `ledger_itc`, `ledger_rcm`, `enable_bill_sunfry`, `enable_sez`, `enable_cheque_deposit`, `enable_billbybill_opening`, `default_sundry`, `enable_salesman`,`default_ledger`) VALUES ('9892', 'TCS', '', '', '31', 'tax_form', '101', '1', '1', '380015', '0', '0', 'CXNSHSSD', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0.00', '0', '0', '0', '0', '0', '0', '9', '0.00', '0', '0', '0', '0', '0', '2021-01-26 14:35:03', '1', '1', '0', '2', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '0', '1', '0', '0', '0', '1', '0','1');



INSERT INTO `tbl_ledger` (`l_id`, `l_name`, `ledger_code`, `emp_profile_img`, `l_group`, `l_form`, `countryid`, `stateid`, `cityid`, `cust_pincode`, `m_name`, `m_address`, `m_pan`, `company_name`, `cust_cont_name`, `cust_mobile`, `cust_email`, `cust_website`, `zone_id`, `cust_assign_user`, `branch_id_customer`, `party_sez`, `branch_id_employee`, `cust_remark`, `gst_no`, `party_type`, `cust_gst_reg`, `pay_terms`, `pay_method`, `bill_type`, `balance_typeid`, `acc_type`, `bankid`, `branch_name`, `acc_name`, `acc_number`, `acc_chequeno`, `acc_chequeleft`, `emp_mobile`, `emp_email`, `emp_password`, `emp_zone_id`, `emp_user_type`, `tax_value`, `opn_balance`, `usertype_terr`, `alloc_stateid`, `alloc_cityid`, `report_to_user_type`, `report_to_user_id`, `cdate`, `user_id`, `company_id`, `l_status`, `print_priority`, `cust_id`, `employee_id`, `branch_id`, `credit_limit`, `credit_days`, `is_deletable`, `ledger_alias`, `enable_multi_currency_opening`, `enable_branch_opening`, `ledger_opening_balance_type`, `enable_cost_center`, `enable_tds`, `party_pay_cat`, `enable_tcs`, `enable_depreciation`, `enable_monthly_budget`, `ledger_Tax_type`, `ledger_gst_applicable`, `ledger_tax_category`, `ledger_hsn`, `ledger_itc`, `ledger_rcm`, `enable_bill_sunfry`, `enable_sez`, `enable_cheque_deposit`, `enable_billbybill_opening`, `default_sundry`, `enable_salesman`, `default_ledger`) VALUES ('24240', 'SALES ACCOUNT', '', '', '25', '0', '101', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.00', '0', '0', '0', '0', '0', '0', '0', '0.00', '0', '0', '0', '2', '1', '2021-01-29 11:01:34', '1', '1', '0', '0', '0', '0', '0', '0', '0', '1', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '1');



INSERT INTO `tbl_ledger` (`l_id`, `l_name`, `ledger_code`, `emp_profile_img`, `l_group`, `l_form`, `countryid`, `stateid`, `cityid`, `cust_pincode`, `m_name`, `m_address`, `m_pan`, `company_name`, `cust_cont_name`, `cust_mobile`, `cust_email`, `cust_website`, `zone_id`, `cust_assign_user`, `branch_id_customer`, `party_sez`, `branch_id_employee`, `cust_remark`, `gst_no`, `party_type`, `cust_gst_reg`, `pay_terms`, `pay_method`, `bill_type`, `balance_typeid`, `acc_type`, `bankid`, `branch_name`, `acc_name`, `acc_number`, `acc_chequeno`, `acc_chequeleft`, `emp_mobile`, `emp_email`, `emp_password`, `emp_zone_id`, `emp_user_type`, `tax_value`, `opn_balance`, `usertype_terr`, `alloc_stateid`, `alloc_cityid`, `report_to_user_type`, `report_to_user_id`, `cdate`, `user_id`, `company_id`, `l_status`, `print_priority`, `cust_id`, `employee_id`, `branch_id`, `credit_limit`, `credit_days`, `is_deletable`, `ledger_alias`, `enable_multi_currency_opening`, `enable_branch_opening`, `ledger_opening_balance_type`, `enable_cost_center`, `enable_tds`, `party_pay_cat`, `enable_tcs`, `enable_depreciation`, `enable_monthly_budget`, `ledger_Tax_type`, `ledger_gst_applicable`, `ledger_tax_category`, `ledger_hsn`, `ledger_itc`, `ledger_rcm`, `enable_bill_sunfry`, `enable_sez`, `enable_cheque_deposit`, `enable_billbybill_opening`, `default_sundry`, `enable_salesman`, `default_ledger`) VALUES ('24430', 'Purchase ACCOUNT', '', '', '25', '0', '101', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.00', '0', '0', '0', '0', '0', '0', '0', '0.00', '0', '0', '0', '2', '1', '2021-01-29 11:01:34', '1', '1', '0', '0', '0', '0', '0', '0', '0', '1', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '1');



INSERT INTO `tbl_ledger` (`l_id`, `l_name`, `ledger_code`, `emp_profile_img`, `l_group`, `l_form`, `countryid`, `stateid`, `cityid`, `cust_pincode`, `m_name`, `m_address`, `m_pan`, `company_name`, `cust_cont_name`, `cust_mobile`, `cust_email`, `cust_website`, `zone_id`, `cust_assign_user`, `branch_id_customer`, `party_sez`, `branch_id_employee`, `cust_remark`, `gst_no`, `party_type`, `cust_gst_reg`, `pay_terms`, `pay_method`, `bill_type`, `balance_typeid`, `acc_type`, `bankid`, `branch_name`, `acc_name`, `acc_number`, `acc_chequeno`, `acc_chequeleft`, `emp_mobile`, `emp_email`, `emp_password`, `emp_zone_id`, `emp_user_type`, `tax_value`, `opn_balance`, `usertype_terr`, `alloc_stateid`, `alloc_cityid`, `report_to_user_type`, `report_to_user_id`, `cdate`, `user_id`, `company_id`, `l_status`, `print_priority`, `cust_id`, `employee_id`, `branch_id`, `credit_limit`, `credit_days`, `is_deletable`, `ledger_alias`, `enable_multi_currency_opening`, `enable_branch_opening`, `ledger_opening_balance_type`, `enable_cost_center`, `enable_tds`, `party_pay_cat`, `enable_tcs`, `enable_depreciation`, `enable_monthly_budget`, `ledger_Tax_type`, `ledger_gst_applicable`, `ledger_tax_category`, `ledger_hsn`, `ledger_itc`, `ledger_rcm`, `enable_bill_sunfry`, `enable_sez`, `enable_cheque_deposit`, `enable_billbybill_opening`, `default_sundry`, `enable_salesman`, `default_ledger`) VALUES ('24449', 'RENT OF PLANT & MACHINERY', '', '', '31', 'tax_form', '101', '1', '1', '380015', '0', '0', 'CXNSHSSD', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0.00', '0', '0', '0', '0', '0', '0', '9', '0.00', '0', '0', '0', '0', '0', '2021-01-26 14:35:03', '1', '1', '0', '2', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '7', '0', '0', '0', '1673', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0');




INSERT INTO `tbl_ledger` (`l_id`, `l_name`, `ledger_code`, `emp_profile_img`, `l_group`, `l_form`, `countryid`, `stateid`, `cityid`, `cust_pincode`, `m_name`, `m_address`, `m_pan`, `company_name`, `cust_cont_name`, `cust_mobile`, `cust_email`, `cust_website`, `zone_id`, `cust_assign_user`, `branch_id_customer`, `party_sez`, `branch_id_employee`, `cust_remark`, `gst_no`, `party_type`, `cust_gst_reg`, `pay_terms`, `pay_method`, `bill_type`, `balance_typeid`, `acc_type`, `bankid`, `branch_name`, `acc_name`, `acc_number`, `acc_chequeno`, `acc_chequeleft`, `emp_mobile`, `emp_email`, `emp_password`, `emp_zone_id`, `emp_user_type`, `tax_value`, `opn_balance`, `usertype_terr`, `alloc_stateid`, `alloc_cityid`, `report_to_user_type`, `report_to_user_id`, `cdate`, `user_id`, `company_id`, `l_status`, `print_priority`, `cust_id`, `employee_id`, `branch_id`, `credit_limit`, `credit_days`, `is_deletable`, `ledger_alias`, `enable_multi_currency_opening`, `enable_branch_opening`, `ledger_opening_balance_type`, `enable_cost_center`, `enable_tds`, `party_pay_cat`, `enable_tcs`, `enable_depreciation`, `enable_monthly_budget`, `ledger_Tax_type`, `ledger_gst_applicable`, `ledger_tax_category`, `ledger_hsn`, `ledger_itc`, `ledger_rcm`, `enable_bill_sunfry`, `enable_sez`, `enable_cheque_deposit`, `enable_billbybill_opening`, `default_sundry`, `enable_salesman`, `default_ledger`) VALUES ('24450', 'Rent of land building furniture etc', '', '', '31', 'tax_form', '101', '1', '1', '380015', '0', '0', 'CXNSHSSD', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0.00', '0', '0', '0', '0', '0', '0', '9', '0.00', '0', '0', '0', '0', '0', '2021-01-26 14:35:03', '1', '1', '0', '2', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '7', '0', '0', '0', '1673', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0');



INSERT INTO `tbl_ledger` (`l_id`, `l_name`, `ledger_code`, `emp_profile_img`, `l_group`, `l_form`, `countryid`, `stateid`, `cityid`, `cust_pincode`, `m_name`, `m_address`, `m_pan`, `company_name`, `cust_cont_name`, `cust_mobile`, `cust_email`, `cust_website`, `zone_id`, `cust_assign_user`, `branch_id_customer`, `party_sez`, `branch_id_employee`, `cust_remark`, `gst_no`, `party_type`, `cust_gst_reg`, `pay_terms`, `pay_method`, `bill_type`, `balance_typeid`, `acc_type`, `bankid`, `branch_name`, `acc_name`, `acc_number`, `acc_chequeno`, `acc_chequeleft`, `emp_mobile`, `emp_email`, `emp_password`, `emp_zone_id`, `emp_user_type`, `tax_value`, `opn_balance`, `usertype_terr`, `alloc_stateid`, `alloc_cityid`, `report_to_user_type`, `report_to_user_id`, `cdate`, `user_id`, `company_id`, `l_status`, `print_priority`, `cust_id`, `employee_id`, `branch_id`, `credit_limit`, `credit_days`, `is_deletable`, `ledger_alias`, `enable_multi_currency_opening`, `enable_branch_opening`, `ledger_opening_balance_type`, `enable_cost_center`, `enable_tds`, `party_pay_cat`, `enable_tcs`, `enable_depreciation`, `enable_monthly_budget`, `ledger_Tax_type`, `ledger_gst_applicable`, `ledger_tax_category`, `ledger_hsn`, `ledger_itc`, `ledger_rcm`, `enable_bill_sunfry`, `enable_sez`, `enable_cheque_deposit`, `enable_billbybill_opening`, `default_sundry`, `enable_salesman`, `default_ledger`) VALUES ('24451', 'Interest other than from a banking Co', '', '', '31', 'tax_form', '101', '1', '1', '380015', '0', '0', 'CXNSHSSD', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0.00', '0', '0', '0', '0', '0', '0', '9', '0.00', '0', '0', '0', '0', '0', '2021-01-26 14:35:03', '1', '1', '0', '2', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '7', '0', '0', '0', '1673', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0');



INSERT INTO `tbl_ledger` (`l_id`, `l_name`, `ledger_code`, `emp_profile_img`, `l_group`, `l_form`, `countryid`, `stateid`, `cityid`, `cust_pincode`, `m_name`, `m_address`, `m_pan`, `company_name`, `cust_cont_name`, `cust_mobile`, `cust_email`, `cust_website`, `zone_id`, `cust_assign_user`, `branch_id_customer`, `party_sez`, `branch_id_employee`, `cust_remark`, `gst_no`, `party_type`, `cust_gst_reg`, `pay_terms`, `pay_method`, `bill_type`, `balance_typeid`, `acc_type`, `bankid`, `branch_name`, `acc_name`, `acc_number`, `acc_chequeno`, `acc_chequeleft`, `emp_mobile`, `emp_email`, `emp_password`, `emp_zone_id`, `emp_user_type`, `tax_value`, `opn_balance`, `usertype_terr`, `alloc_stateid`, `alloc_cityid`, `report_to_user_type`, `report_to_user_id`, `cdate`, `user_id`, `company_id`, `l_status`, `print_priority`, `cust_id`, `employee_id`, `branch_id`, `credit_limit`, `credit_days`, `is_deletable`, `ledger_alias`, `enable_multi_currency_opening`, `enable_branch_opening`, `ledger_opening_balance_type`, `enable_cost_center`, `enable_tds`, `party_pay_cat`, `enable_tcs`, `enable_depreciation`, `enable_monthly_budget`, `ledger_Tax_type`, `ledger_gst_applicable`, `ledger_tax_category`, `ledger_hsn`, `ledger_itc`, `ledger_rcm`, `enable_bill_sunfry`, `enable_sez`, `enable_cheque_deposit`, `enable_billbybill_opening`, `default_sundry`, `enable_salesman`, `default_ledger`) VALUES ('24452', 'Interest from a banking company', '', '', '31', 'tax_form', '101', '1', '1', '380015', '0', '0', 'CXNSHSSD', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0.00', '0', '0', '0', '0', '0', '0', '9', '0.00', '0', '0', '0', '0', '0', '2021-01-26 14:35:03', '1', '1', '0', '2', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '7', '0', '0', '0', '1673', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0');



INSERT INTO `tbl_ledger` (`l_id`, `l_name`, `ledger_code`, `emp_profile_img`, `l_group`, `l_form`, `countryid`, `stateid`, `cityid`, `cust_pincode`, `m_name`, `m_address`, `m_pan`, `company_name`, `cust_cont_name`, `cust_mobile`, `cust_email`, `cust_website`, `zone_id`, `cust_assign_user`, `branch_id_customer`, `party_sez`, `branch_id_employee`, `cust_remark`, `gst_no`, `party_type`, `cust_gst_reg`, `pay_terms`, `pay_method`, `bill_type`, `balance_typeid`, `acc_type`, `bankid`, `branch_name`, `acc_name`, `acc_number`, `acc_chequeno`, `acc_chequeleft`, `emp_mobile`, `emp_email`, `emp_password`, `emp_zone_id`, `emp_user_type`, `tax_value`, `opn_balance`, `usertype_terr`, `alloc_stateid`, `alloc_cityid`, `report_to_user_type`, `report_to_user_id`, `cdate`, `user_id`, `company_id`, `l_status`, `print_priority`, `cust_id`, `employee_id`, `branch_id`, `credit_limit`, `credit_days`, `is_deletable`, `ledger_alias`, `enable_multi_currency_opening`, `enable_branch_opening`, `ledger_opening_balance_type`, `enable_cost_center`, `enable_tds`, `party_pay_cat`, `enable_tcs`, `enable_depreciation`, `enable_monthly_budget`, `ledger_Tax_type`, `ledger_gst_applicable`, `ledger_tax_category`, `ledger_hsn`, `ledger_itc`, `ledger_rcm`, `enable_bill_sunfry`, `enable_sez`, `enable_cheque_deposit`, `enable_billbybill_opening`, `default_sundry`, `enable_salesman`, `default_ledger`) VALUES ('24453', 'Gross Pymt/Purc', '', '', '31', 'tax_form', '101', '1', '1', '380015', '0', '0', 'CXNSHSSD', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0.00', '0', '0', '0', '0', '0', '0', '9', '0.00', '0', '0', '0', '0', '0', '2021-01-26 14:35:03', '1', '1', '0', '2', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '7', '0', '0', '0', '1673', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0');



INSERT INTO `tbl_ledger` (`l_id`, `l_name`, `ledger_code`, `emp_profile_img`, `l_group`, `l_form`, `countryid`, `stateid`, `cityid`, `cust_pincode`, `m_name`, `m_address`, `m_pan`, `company_name`, `cust_cont_name`, `cust_mobile`, `cust_email`, `cust_website`, `zone_id`, `cust_assign_user`, `branch_id_customer`, `party_sez`, `branch_id_employee`, `cust_remark`, `gst_no`, `party_type`, `cust_gst_reg`, `pay_terms`, `pay_method`, `bill_type`, `balance_typeid`, `acc_type`, `bankid`, `branch_name`, `acc_name`, `acc_number`, `acc_chequeno`, `acc_chequeleft`, `emp_mobile`, `emp_email`, `emp_password`, `emp_zone_id`, `emp_user_type`, `tax_value`, `opn_balance`, `usertype_terr`, `alloc_stateid`, `alloc_cityid`, `report_to_user_type`, `report_to_user_id`, `cdate`, `user_id`, `company_id`, `l_status`, `print_priority`, `cust_id`, `employee_id`, `branch_id`, `credit_limit`, `credit_days`, `is_deletable`, `ledger_alias`, `enable_multi_currency_opening`, `enable_branch_opening`, `ledger_opening_balance_type`, `enable_cost_center`, `enable_tds`, `party_pay_cat`, `enable_tcs`, `enable_depreciation`, `enable_monthly_budget`, `ledger_Tax_type`, `ledger_gst_applicable`, `ledger_tax_category`, `ledger_hsn`, `ledger_itc`, `ledger_rcm`, `enable_bill_sunfry`, `enable_sez`, `enable_cheque_deposit`, `enable_billbybill_opening`, `default_sundry`, `enable_salesman`, `default_ledger`) VALUES ('24454', 'FEES FOR TECHNICAL SERVICES', '', '', '31', 'tax_form', '101', '1', '1', '380015', '0', '0', 'CXNSHSSD', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0.00', '0', '0', '0', '0', '0', '0', '9', '0.00', '0', '0', '0', '0', '0', '2021-01-26 14:35:03', '1', '1', '0', '2', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '7', '0', '0', '0', '1673', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0');



INSERT INTO `tbl_ledger` (`l_id`, `l_name`, `ledger_code`, `emp_profile_img`, `l_group`, `l_form`, `countryid`, `stateid`, `cityid`, `cust_pincode`, `m_name`, `m_address`, `m_pan`, `company_name`, `cust_cont_name`, `cust_mobile`, `cust_email`, `cust_website`, `zone_id`, `cust_assign_user`, `branch_id_customer`, `party_sez`, `branch_id_employee`, `cust_remark`, `gst_no`, `party_type`, `cust_gst_reg`, `pay_terms`, `pay_method`, `bill_type`, `balance_typeid`, `acc_type`, `bankid`, `branch_name`, `acc_name`, `acc_number`, `acc_chequeno`, `acc_chequeleft`, `emp_mobile`, `emp_email`, `emp_password`, `emp_zone_id`, `emp_user_type`, `tax_value`, `opn_balance`, `usertype_terr`, `alloc_stateid`, `alloc_cityid`, `report_to_user_type`, `report_to_user_id`, `cdate`, `user_id`, `company_id`, `l_status`, `print_priority`, `cust_id`, `employee_id`, `branch_id`, `credit_limit`, `credit_days`, `is_deletable`, `ledger_alias`, `enable_multi_currency_opening`, `enable_branch_opening`, `ledger_opening_balance_type`, `enable_cost_center`, `enable_tds`, `party_pay_cat`, `enable_tcs`, `enable_depreciation`, `enable_monthly_budget`, `ledger_Tax_type`, `ledger_gst_applicable`, `ledger_tax_category`, `ledger_hsn`, `ledger_itc`, `ledger_rcm`, `enable_bill_sunfry`, `enable_sez`, `enable_cheque_deposit`, `enable_billbybill_opening`, `default_sundry`, `enable_salesman`, `default_ledger`) VALUES ('24455', 'FEES FOR PROFESSIONAL SERVICES', '', '', '31', 'tax_form', '101', '1', '1', '380015', '0', '0', 'CXNSHSSD', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0.00', '0', '0', '0', '0', '0', '0', '9', '0.00', '0', '0', '0', '0', '0', '2021-01-26 14:35:03', '1', '1', '0', '2', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '7', '0', '0', '0', '1673', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0');




INSERT INTO `tbl_ledger` (`l_id`, `l_name`, `ledger_code`, `emp_profile_img`, `l_group`, `l_form`, `countryid`, `stateid`, `cityid`, `cust_pincode`, `m_name`, `m_address`, `m_pan`, `company_name`, `cust_cont_name`, `cust_mobile`, `cust_email`, `cust_website`, `zone_id`, `cust_assign_user`, `branch_id_customer`, `party_sez`, `branch_id_employee`, `cust_remark`, `gst_no`, `party_type`, `cust_gst_reg`, `pay_terms`, `pay_method`, `bill_type`, `balance_typeid`, `acc_type`, `bankid`, `branch_name`, `acc_name`, `acc_number`, `acc_chequeno`, `acc_chequeleft`, `emp_mobile`, `emp_email`, `emp_password`, `emp_zone_id`, `emp_user_type`, `tax_value`, `opn_balance`, `usertype_terr`, `alloc_stateid`, `alloc_cityid`, `report_to_user_type`, `report_to_user_id`, `cdate`, `user_id`, `company_id`, `l_status`, `print_priority`, `cust_id`, `employee_id`, `branch_id`, `credit_limit`, `credit_days`, `is_deletable`, `ledger_alias`, `enable_multi_currency_opening`, `enable_branch_opening`, `ledger_opening_balance_type`, `enable_cost_center`, `enable_tds`, `party_pay_cat`, `enable_tcs`, `enable_depreciation`, `enable_monthly_budget`, `ledger_Tax_type`, `ledger_gst_applicable`, `ledger_tax_category`, `ledger_hsn`, `ledger_itc`, `ledger_rcm`, `enable_bill_sunfry`, `enable_sez`, `enable_cheque_deposit`, `enable_billbybill_opening`, `default_sundry`, `enable_salesman`, `default_ledger`) VALUES ('24456', 'FEES FOR PROFESSIONAL OR TECH.SERVICES', '', '', '31', 'tax_form', '101', '1', '1', '380015', '0', '0', 'CXNSHSSD', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0.00', '0', '0', '0', '0', '0', '0', '9', '0.00', '0', '0', '0', '0', '0', '2021-01-26 14:35:03', '1', '1', '0', '2', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '7', '0', '0', '0', '1673', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0');



INSERT INTO `tbl_ledger` (`l_id`, `l_name`, `ledger_code`, `emp_profile_img`, `l_group`, `l_form`, `countryid`, `stateid`, `cityid`, `cust_pincode`, `m_name`, `m_address`, `m_pan`, `company_name`, `cust_cont_name`, `cust_mobile`, `cust_email`, `cust_website`, `zone_id`, `cust_assign_user`, `branch_id_customer`, `party_sez`, `branch_id_employee`, `cust_remark`, `gst_no`, `party_type`, `cust_gst_reg`, `pay_terms`, `pay_method`, `bill_type`, `balance_typeid`, `acc_type`, `bankid`, `branch_name`, `acc_name`, `acc_number`, `acc_chequeno`, `acc_chequeleft`, `emp_mobile`, `emp_email`, `emp_password`, `emp_zone_id`, `emp_user_type`, `tax_value`, `opn_balance`, `usertype_terr`, `alloc_stateid`, `alloc_cityid`, `report_to_user_type`, `report_to_user_id`, `cdate`, `user_id`, `company_id`, `l_status`, `print_priority`, `cust_id`, `employee_id`, `branch_id`, `credit_limit`, `credit_days`, `is_deletable`, `ledger_alias`, `enable_multi_currency_opening`, `enable_branch_opening`, `ledger_opening_balance_type`, `enable_cost_center`, `enable_tds`, `party_pay_cat`, `enable_tcs`, `enable_depreciation`, `enable_monthly_budget`, `ledger_Tax_type`, `ledger_gst_applicable`, `ledger_tax_category`, `ledger_hsn`, `ledger_itc`, `ledger_rcm`, `enable_bill_sunfry`, `enable_sez`, `enable_cheque_deposit`, `enable_billbybill_opening`, `default_sundry`, `enable_salesman`, `default_ledger`) VALUES ('24457', 'CONTRACTS TO TRANSPORTER', '', '', '31', 'tax_form', '101', '1', '1', '380015', '0', '0', 'CXNSHSSD', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0.00', '0', '0', '0', '0', '0', '0', '9', '0.00', '0', '0', '0', '0', '0', '2021-01-26 14:35:03', '1', '1', '0', '2', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '7', '0', '0', '0', '1673', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0');



INSERT INTO `tbl_ledger` (`l_id`, `l_name`, `ledger_code`, `emp_profile_img`, `l_group`, `l_form`, `countryid`, `stateid`, `cityid`, `cust_pincode`, `m_name`, `m_address`, `m_pan`, `company_name`, `cust_cont_name`, `cust_mobile`, `cust_email`, `cust_website`, `zone_id`, `cust_assign_user`, `branch_id_customer`, `party_sez`, `branch_id_employee`, `cust_remark`, `gst_no`, `party_type`, `cust_gst_reg`, `pay_terms`, `pay_method`, `bill_type`, `balance_typeid`, `acc_type`, `bankid`, `branch_name`, `acc_name`, `acc_number`, `acc_chequeno`, `acc_chequeleft`, `emp_mobile`, `emp_email`, `emp_password`, `emp_zone_id`, `emp_user_type`, `tax_value`, `opn_balance`, `usertype_terr`, `alloc_stateid`, `alloc_cityid`, `report_to_user_type`, `report_to_user_id`, `cdate`, `user_id`, `company_id`, `l_status`, `print_priority`, `cust_id`, `employee_id`, `branch_id`, `credit_limit`, `credit_days`, `is_deletable`, `ledger_alias`, `enable_multi_currency_opening`, `enable_branch_opening`, `ledger_opening_balance_type`, `enable_cost_center`, `enable_tds`, `party_pay_cat`, `enable_tcs`, `enable_depreciation`, `enable_monthly_budget`, `ledger_Tax_type`, `ledger_gst_applicable`, `ledger_tax_category`, `ledger_hsn`, `ledger_itc`, `ledger_rcm`, `enable_bill_sunfry`, `enable_sez`, `enable_cheque_deposit`, `enable_billbybill_opening`, `default_sundry`, `enable_salesman`, `default_ledger`) VALUES ('24458', 'Contracts to others', '', '', '31', 'tax_form', '101', '1', '1', '380015', '0', '0', 'CXNSHSSD', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0.00', '0', '0', '0', '0', '0', '0', '9', '0.00', '0', '0', '0', '0', '0', '2021-01-26 14:35:03', '1', '1', '0', '2', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '7', '0', '0', '0', '1673', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0');


INSERT INTO `tbl_ledger` (`l_id`, `l_name`, `ledger_code`, `emp_profile_img`, `l_group`, `l_form`, `countryid`, `stateid`, `cityid`, `cust_pincode`, `m_name`, `m_address`, `m_pan`, `company_name`, `cust_cont_name`, `cust_mobile`, `cust_email`, `cust_website`, `zone_id`, `cust_assign_user`, `branch_id_customer`, `party_sez`, `branch_id_employee`, `cust_remark`, `gst_no`, `party_type`, `cust_gst_reg`, `pay_terms`, `pay_method`, `bill_type`, `balance_typeid`, `acc_type`, `bankid`, `branch_name`, `acc_name`, `acc_number`, `acc_chequeno`, `acc_chequeleft`, `emp_mobile`, `emp_email`, `emp_password`, `emp_zone_id`, `emp_user_type`, `tax_value`, `opn_balance`, `usertype_terr`, `alloc_stateid`, `alloc_cityid`, `report_to_user_type`, `report_to_user_id`, `cdate`, `user_id`, `company_id`, `l_status`, `print_priority`, `cust_id`, `employee_id`, `branch_id`, `credit_limit`, `credit_days`, `is_deletable`, `ledger_alias`, `enable_multi_currency_opening`, `enable_branch_opening`, `ledger_opening_balance_type`, `enable_cost_center`, `enable_tds`, `party_pay_cat`, `enable_tcs`, `enable_depreciation`, `enable_monthly_budget`, `ledger_Tax_type`, `ledger_gst_applicable`, `ledger_tax_category`, `ledger_hsn`, `ledger_itc`, `ledger_rcm`, `enable_bill_sunfry`, `enable_sez`, `enable_cheque_deposit`, `enable_billbybill_opening`, `default_sundry`, `enable_salesman`, `default_ledger`) VALUES ('24459', 'CONTRACTS AND INDIVIDUALS/HUF', '', '', '31', 'tax_form', '101', '1', '1', '380015', '0', '0', 'CXNSHSSD', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0.00', '0', '0', '0', '0', '0', '0', '9', '0.00', '0', '0', '0', '0', '0', '2021-01-26 14:35:03', '1', '1', '0', '2', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '7', '0', '0', '0', '1673', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `tbl_ledger` (`l_id`, `l_name`, `ledger_code`, `emp_profile_img`, `l_group`, `l_form`, `countryid`, `stateid`, `cityid`, `cust_pincode`, `m_name`, `m_address`, `m_pan`, `company_name`, `cust_cont_name`, `cust_mobile`, `cust_email`, `cust_website`, `zone_id`, `cust_assign_user`, `branch_id_customer`, `party_sez`, `branch_id_employee`, `cust_remark`, `gst_no`, `party_type`, `cust_gst_reg`, `pay_terms`, `pay_method`, `bill_type`, `balance_typeid`, `acc_type`, `bankid`, `branch_name`, `acc_name`, `acc_number`, `acc_chequeno`, `acc_chequeleft`, `emp_mobile`, `emp_email`, `emp_password`, `emp_zone_id`, `emp_user_type`, `tax_value`, `opn_balance`, `usertype_terr`, `alloc_stateid`, `alloc_cityid`, `report_to_user_type`, `report_to_user_id`, `cdate`, `user_id`, `company_id`, `l_status`, `print_priority`, `cust_id`, `employee_id`, `branch_id`, `credit_limit`, `credit_days`, `is_deletable`, `ledger_alias`, `enable_multi_currency_opening`, `enable_branch_opening`, `ledger_opening_balance_type`, `enable_cost_center`, `enable_tds`, `party_pay_cat`, `enable_tcs`, `enable_depreciation`, `enable_monthly_budget`, `ledger_Tax_type`, `ledger_gst_applicable`, `ledger_tax_category`, `ledger_hsn`, `ledger_itc`, `ledger_rcm`, `enable_bill_sunfry`, `enable_sez`, `enable_cheque_deposit`, `enable_billbybill_opening`, `default_sundry`, `enable_salesman`, `default_ledger`) VALUES ('24460', 'COMMISSION AND BROKRAGE', '', '', '31', 'tax_form', '101', '1', '1', '380015', '0', '0', 'CXNSHSSD', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0.00', '0', '0', '0', '0', '0', '0', '9', '0.00', '0', '0', '0', '0', '0', '2021-01-26 14:35:03', '1', '1', '0', '2', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '7', '0', '0', '0', '1673', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0');



INSERT INTO `branch_mst` (`branch_id`, `branch_user_id`, `branch_name`, `branch_email`, `branch_password`, `branch_address`, `zoneid`, `countryid`, `stateid`, `cityid`, `branch_pincode`, `branch_status`, `cdate`, `user_id`, `usertype_id`, `company_id`) VALUES ('1000', '0', 'All Branch', '', '', 'Address BRANCH 1', '0', '101', '1', '1', '380015', '0', '2021-03-01 20:59:07', '125', '2', '4');


